SELECT Id FROM new_searchtable
where (town like 'Lyme' or town like 'Enfield' or town like 'Plainfield' or town like 'Cornish') and (type = 'R' or type ='O')
AND list_price BETWEEN '250000' AND '500000'
ORDER BY list_price Desc
Upper Valley NH Homes page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:A fantastic location, just 15 or 20 minutes to the Upper Valley or New London area on paved roads. Traditional layout with updates of new kitchen, baths, windows, spray foam insulation, plus many original features add to the charm with refinished wide pine floors, moldings, 4 panel solid wood doors, and built ins. Kitchen/Dining with new flooring, former summer kitchen is now a 3 season hobby room with woodstove, 2 baths on the first floor, one bath has a washer/dryer that are included. Depending on how you want to use the rooms you could have a formal dining room for family gatherings over the holidays, there is a primary bedroom & bath, music/office room on the first floor, and two bedrooms on the second floor. 3.3 surveyed acres+/- with Knox River frontage to cool off next to, beautiful backyard with rolling lawns, apple trees, and a foot bridge to the unspoiled woodlands. Attached ell with storage above as well as loft above the barn. Enjoy all the area has to offer with Farmer's Market on Saturday, Concerts, area lakes/ponds with public access. Dartmouth College, VA hospital, & Dartmouth Medical Center are within convenient travel time.